# -*- coding: UTF-8 _*_
from openpyxl import load_workbook
from config.config import base_path


class ReadCase():
    @classmethod
    def parse_xlsx(cls, filepath=base_path, filename='', sheet_name="Sheet1"):
        excel = load_workbook(filepath + filename)
        data = []
        for value in excel[sheet_name].values:
            # excle从第一行读取，屏蔽表头
            if value[0] != '编号':
                # 去掉第一列
                data.append(value[1:])
        excel.close()
        # print(data)
        return data
